gvSIG-Desktop 1.10. User Manual

The tool for joining tables has been improved and now reflects the relationship between the tables once they have been joined. The operation of the tool remains the same in that both tables must contain a common field that will be used to join them together.

Dialog for joining tables

It is possible to add a prefix to the source table fields so that they can be easily identified in the joined table, e.g. Table1_FIELD1, Table1_FIELD2, etc. In a similar manner a prefix can also be added to the target table fields: Table2_FIELD1, Table2_FIELD2, etc.

The resulting joined table is given a title made up of the tables participating in the join, e.g. Table1 X Table2 X, or vice versa.

Result of the table join

The join between the tables can be removed by selecting 'Remove joins' from the Table menu.

• Note: A layer can't be edited once a join has been established on it and the "Start Editing" option on the layer's context menu will be disabled. To start an editing session go to the Table menu and remove the existing joins.